/*
 Navicat Premium Data Transfer

 Source Server         : mysql(root)
 Source Server Type    : MySQL
 Source Server Version : 80020
 Source Host           : localhost:3306
 Source Schema         : libraryms

 Target Server Type    : MySQL
 Target Server Version : 80020
 File Encoding         : 65001

 Date: 03/05/2021 19:52:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_book
-- ----------------------------
DROP TABLE IF EXISTS `t_book`;
CREATE TABLE `t_book`  (
  `id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'uuid',
  `serialNumber` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书标识号（入库年月+位置号）',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书名',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `press` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出版社',
  `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',
  `price` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '价格',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类别',
  `stock` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '库存',
  `location` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置',
  `borrows` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '借出数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of t_book
-- ----------------------------
BEGIN;
INSERT INTO `t_book` VALUES ('14b5ea918c0d4e91b68608910a5edfc4', '202104F13', '普林斯顿微积分读本', '77dea8c675bc48d2aa899621f4e0eede普林斯顿微积分读本.jpg', '人民邮电出版社', '阿德里安·班纳', '66', '自然科学类', '4', 'F-1-3', '2'), ('2f492d9b6732426794b00852fd252c6e', '202104D13', '血液病诊断及疗效标准', '4d0de3e87ed646c6a2ae685ea47eb880血液病诊断及疗效标准.jpg', '科学出版社', '赵永强', '78', '医学类', '3', 'D-1-3', '0'), ('4cefe1d0c75a4c09b7b48fffcce4753c', '202104A11', 'C++', '61d5ab0e90c247feb0b3a9d206781730C++.jpg', '人民邮电出版社', '史蒂芬·普拉达', '79', '计算机类', '5', 'A-1-1', '0'), ('58a5c4063c09467b8873fecfe53ea636', '202104F12', '几何原本', '0a2eb24ae87840ed9a9400090d37585a几何原本.jpg', '江苏人民出版社', '欧几里得', '42', '自然科学类', '4', 'F-1-2', '0'), ('62a19d2a81bc4cfc8d0a0f6633d4f59c', '202104B12', '微积分的力量', 'd9b7870e2a214c4ba8dab2f34ba42698微积分的力量.jpg', '中信出版社', '史蒂夫·斯托加茨', '52', '科普类', '3', 'B-1-2', '0'), ('630dc558a6aa40379883b4bac36d8f9a', '202104D12', '黄帝内针讲义', '1476d6e53cfa40eb91ebace7db15de00黄帝内针讲义.jpg', '中国中医药出版社', '刘力红', '32', '医学类', '4', 'D-1-2', '0'), ('6e90d9c8c05d4d3faf92660462eba8a9', '202104E11', '世界热带鱼图鉴', '37c279bf43c24d70ba3000580506615c世界热带鱼图鉴.jpg', '中国民族文化出版社有限公司', '小林道信', '63', '农林类', '4', 'E-1-1', '0'), ('6f67f08841044453a377a41b055276cf', '202104C12', '建筑的想象', '32dd098051f74bb1b843ac5c05bcde54建筑的想象.jpg', '北京大学出版社', '迪恩·霍克斯', '85', '建筑类', '1', 'C-1-2', '0'), ('762470b2bbd94adb8a47b0ebdc8dc6d1', '202104E12', '景观园林植物图鉴', 'c0eaca554ca84c23addc4fe6645c1f2b景观园林植物图鉴.jpg', '河南科学技术出版社', '闫双喜', '123', '农林类', '4', 'E-1-2', '0'), ('79851931242540cf97fa1a229555d9ba', '202104A12', '数学之美', 'b4c76ccba0844cac92762ccdaa6a116a数学之美.jpg', '人民邮电出版社', '吴军', '66', '计算机类', '4', 'A-1-2', '0'), ('79ee93488d754fc3aa402f7ccdda8b2e', '202104A13', '深入理解Java虚拟机', '99f859b6b22d43318b59df858daad045深入理解Java虚拟机.jpg', '机械工业出版社', '周志明', '83', '计算机类', '4', 'A-1-3', '0'), ('82135c65882546f19eb360702217c9ff', '202104B11', '我们为什么要睡觉？', 'f47080098d754a6a89bbcc664eb41283我们为什么要睡觉？.jpg', '北京联合出版有限公司', '马修·沃克', '45', '科普类', '2', 'B-1-1', '0'), ('8673ebd827054a31bf0d95d36a025565', '202104F11', '吴军数学通识讲义', '9316f2ed3c8e4710a55cbc4eebe6fe16吴军数学通识讲义.jpg', '新星出版社', '吴军', '64', '自然科学类', '2', 'F-1-1', '0'), ('a364448d000c4899bafa010c6a1bf187', '202104E13', '四千年农夫', 'f25ff940804c4d19970d2e5ada6a661c四千年农夫.jpg', '东方出版社', '富兰克林.H.金', '43', '农林类', '2', 'E-1-3', '0'), ('a4ed97afba494856841d47f0d2c30b09', '202104C11', '榫卯的魅力', 'd62befae4b4947279b10c997a4bf0d98榫卯的魅力.jpg', '化学工业出版社', '张瑶', '94', '建筑类', '2', 'C-1-1', '0'), ('aff027bf01c546d5aec047268af2db0e', '202104D11', '孙思邈医学全书', '65cb94e0c2864ca7b0134a4b07a67382孙思邈医学全书.jpg', '山西科学技术出版社', '唐·孙思邈', '119', '医学类', '2', 'D-1-1', '0'), ('b818c9fedd2c45a68b2216ebeaf61d87', '202104B13', '果壳中的宇宙', 'b1515c8f73fd41458d6f861804b8cb9b果壳中的宇宙.jpg', '湖南科技出版社', '史蒂芬·霍金', '42', '科普类', '5', 'B-1-3', '0'), ('c015aee801dd4c168a671bf2483e9beb', '202104C13', '古拙：梁思成笔下的古建之美', 'd6a07b2a593f43e8b7d136ee3c422ea6古拙：梁思成笔下的古建之美.jpg', '中国青年出版社', '梁思成', '55', '建筑类', '4', 'C-1-3', '0'), ('c6befc51179947b2b8a3b2991d041dcb', '202104E12', '实用养猪大全', 'a1eb0cea0f73435db7ae2394e1aa5350实用养猪大全.jpg', '河南科学技术出版社', '白红杰', '24', '农林类', '88', 'E-1-2', '0'), ('e27e77e5eb63429382bf5686fe6a5446', '202104A21', 'labuladong的算法小抄', '9975da39988c4439b1ddfb9af4efaf0blabuladong的算法小抄.jpg', '电子工业出版社', '付东来', '88', '计算机类', '3', 'A-2-1', '0'), ('e6c35d6fea7c49eab19c9f3c805f211b', '202104G13', '机械设计', 'fa1f56c1951747c2b7e0559a39552def机械设计.jpg', '机械工业出版社', '罗伯特.诺顿', '157', '工业类', '5', 'G-1-3', '0'), ('e76855cbc5534315a32f21a9eeda28d1', '202104G12', '电气工程设计与计算550例', 'ef79b14cf4f54d989ff8012ce260983a电气工程设计与计算550例.jpg', '化学工业出版社', '方大千', '161', '工业类', '4', 'G-1-2', '0'), ('e998ce9715134832993990c1475d6bf0', '202104A14', '高性能MySQL', '22853c624ab249ecaa5800a40e5b8276高性能MySQL.jpg', '电子工业出版社', '施瓦茨', '122', '计算机类', '6', 'A-1-4', '0'), ('f92ed1a5b827472ab25836b6e5e8e8b6', '202104G11', '全彩图解电工电路', '820cdaa80b264018a7bfbe6600b1a435全彩图解电工电路.jpg', '化学工业出版社', '乔长君', '46', '工业类', '4', 'G-1-1', '0');
COMMIT;

-- ----------------------------
-- Table structure for t_borrow
-- ----------------------------
DROP TABLE IF EXISTS `t_borrow`;
CREATE TABLE `t_borrow`  (
  `id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'uuid',
  `userId` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',
  `bookId` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '书籍id',
  `borrowDate` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '借书日期',
  `borrowTime` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '借书时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of t_borrow
-- ----------------------------
BEGIN;
INSERT INTO `t_borrow` VALUES ('03ee6128e7214ff3897e30bfbe6d9aec', '3', '630dc558a6aa40379883b4bac36d8f9a', '2021-04-30', '3'), ('0afbde808d624cce996c7fd112b7e331', '3', '6e90d9c8c05d4d3faf92660462eba8a9', '2021-04-27', '2'), ('27f6cc85b9dc4f2fa8a22cad7a96a1bb', '3', '62a19d2a81bc4cfc8d0a0f6633d4f59c', '2021-04-30', '180'), ('83f3ff82f20245b58464424862c4c30f', '3', '2f492d9b6732426794b00852fd252c6e', '2021-04-30', '180'), ('95a83c871e764c50b32d2a7212b3cbd3', '3', '14b5ea918c0d4e91b68608910a5edfc4', '2021-04-30', '180'), ('9c1474a16a4b4eafa37f8f60c04c6f26', '3', 'f92ed1a5b827472ab25836b6e5e8e8b6', '2021-04-30', '180'), ('b062b2cd8c2242ada1ed8a4ef61f4707', '3', '4cefe1d0c75a4c09b7b48fffcce4753c', '2021-04-30', '180'), ('b99f9561c68048b48e61ef2cb3756e26', '3', 'e998ce9715134832993990c1475d6bf0', '2021-04-30', '180');
COMMIT;

-- ----------------------------
-- Table structure for t_borrow_history
-- ----------------------------
DROP TABLE IF EXISTS `t_borrow_history`;
CREATE TABLE `t_borrow_history`  (
  `id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'uuid',
  `userId` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号',
  `bookId` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图书名',
  `borrowDate` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '借书日期',
  `returnDate` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '还书日期',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '完成状态',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of t_borrow_history
-- ----------------------------
BEGIN;
INSERT INTO `t_borrow_history` VALUES ('c1ddc24e22c14f889f23c18ee9ecbfa1', '3', '333', '4cefe1d0c75a4c09b7b48fffcce4753c', 'C++', '2021-04-27', '2021-04-30', '按时归还');
COMMIT;

-- ----------------------------
-- Table structure for t_dic_type
-- ----------------------------
DROP TABLE IF EXISTS `t_dic_type`;
CREATE TABLE `t_dic_type`  (
  `id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'uuid',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典类型',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of t_dic_type
-- ----------------------------
BEGIN;
INSERT INTO `t_dic_type` VALUES ('97d1128f70294f0aac49e996ced28c8a', 'sex', '性别'), ('97d1128f70294f0aac49e996ced28c8b', 'role', '角色'), ('97d1128f70294f0aac49e996ced28c8c', 'type', '书籍类别'), ('97d1128f70294f0aac49e996ced28c8d', 'status', '借阅完成状态');
COMMIT;

-- ----------------------------
-- Table structure for t_dic_value
-- ----------------------------
DROP TABLE IF EXISTS `t_dic_value`;
CREATE TABLE `t_dic_value`  (
  `id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'uuid',
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '不能为空，并且要求同一个字典类型下字典值不能重复，具有唯一性。',
  `orderNo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '排列序号',
  `typeid` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典类型id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of t_dic_value
-- ----------------------------
BEGIN;
INSERT INTO `t_dic_value` VALUES ('06e3cbdf10a44eca8511dddfc6896c55', '男', '1', '97d1128f70294f0aac49e996ced28c8a'), ('08cbadfec89540849e058c00eddabc71', '保密', '3', '97d1128f70294f0aac49e996ced28c8a'), ('0fe33840c6d84bf78df55d49b169a894', '女', '2', '97d1128f70294f0aac49e996ced28c8a'), ('1615f0bb3e604552a86cde9a2ad45bea', '用户', '1', '97d1128f70294f0aac49e996ced28c8b'), ('176039d2a90e4b1a81c5ab8707268636', '管理员', '2', '97d1128f70294f0aac49e996ced28c8b'), ('1e0bd307e6ee425599327447f8387285', '超级管理员', '3', '97d1128f70294f0aac49e996ced28c8b'), ('2173663b40b949ce928db92607b5fe57', '计算机类', '1', '97d1128f70294f0aac49e996ced28c8c'), ('2876690b7e744333b7f1867102f91153', '人文类', '2', '97d1128f70294f0aac49e996ced28c8c'), ('29805c804dd94974b568cfc9017b2e4c', '自然科学类', '3', '97d1128f70294f0aac49e996ced28c8c'), ('2e16a13f66e445a29c5e271fd110b624', '书籍丢失', '4', '97d1128f70294f0aac49e996ced28c8d'), ('310e6a49bd8a4962b3f95a1d92eb76f4', '科普类', '4', '97d1128f70294f0aac49e996ced28c8c'), ('31539e7ed8c848fc913e1c2c93d76fd1', '建筑类', '5', '97d1128f70294f0aac49e996ced28c8c'), ('37ef211719134b009e10b7108194cf46', '农林类', '6', '97d1128f70294f0aac49e996ced28c8c'), ('3a39605d67da48f2a3ef52e19d243953', '杂志', '8', '97d1128f70294f0aac49e996ced28c8c'), ('3aa6d7fcdc11435d98d575d8f4b0b72e', '逾期且已交罚金', '2', '97d1128f70294f0aac49e996ced28c8d'), ('474ab93e2e114816abf3ffc596b19131', '漫画', '9', '97d1128f70294f0aac49e996ced28c8c'), ('48512bfed26145d4a38d3616e2d2cf79', '工业类', '10', '97d1128f70294f0aac49e996ced28c8c'), ('4d03a42898684135809d380597ed3268', '医学类', '11', '97d1128f70294f0aac49e996ced28c8c'), ('7eb48a57cead4ea58a20e1be1cf59796', '后台删除', '5', '97d1128f70294f0aac49e996ced28c8d'), ('ce0752d7dae540e29234d0d322049cc5', '逾期但未交罚金', '3', '97d1128f70294f0aac49e996ced28c8d'), ('e44bc99d6aed479f89aa4408d4e09d83', '按时归还', '1', '97d1128f70294f0aac49e996ced28c8d');
COMMIT;

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'uuid',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `role` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色',
  `phone` char(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `sex` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `borrowBookLimit` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '借书限制1~99本',
  `borrowTimeLimit` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '借书时间1~999天',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of t_user
-- ----------------------------
BEGIN;
INSERT INTO `t_user` VALUES ('1', 'SuperAdmin', '111', '698d51a19d8a121ce581499d7b701668', '超级管理员', '13005134802', '男', '0', '0'), ('2', 'Admin', '222', 'bcbe3365e6ac95ea2c0343a2395834dd', '管理员', '13005134802', '男', '0', '0'), ('3', 'User', '333', '310dcbbf4cce62f762a2aaa148d556bd', '用户', '13005134802', '男', '8', '180'), ('8555491576e1412eba28210f0b8546c4', 'TestSaveUser1', '444', '698d51a19d8a121ce581499d7b701668', '管理员', '13005134802', '男', '0', '0'), ('fbcd06df829f473da7a14b7672049a96', 'test', '555', '15de21c670ae7c3f6f3f1f37029303c9', '用户', '13005134802', '男', '5', '15');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
